Create table Helmet.HelmetInfo
(
Helmet_InfoID int not null,
HelmetVariationData_InfoID INT NOT NULL,
Department_Arr10 nvarchar(500),
StyleKeywords_Arr10 nvarchar(max),
SafetyRating_Arr10 nvarchar(150),
ModelName nvarchar(50),
ModelYear int ,
Season nvarchar(50),
HelmetColorSpecificationInfo_InfoID int ,
Material nvarchar(50),
InnerMaterial nvarchar(50),
OuterMaterial nvarchar(50),
OccasionAndLifestyle_Arr10 nvarchar(max),
EventKeywords_Arr10 nvarchar(max),
StyleName nvarchar(50),
CountryOfOrigin nvarchar(50),
IsAdultProduct bit,
Size nvarchar(50),
SizeMap nvarchar(15),
SpecialSizeType_Arr10 nvarchar(500),
ItemPackageQuantity int default 1,
ManufacturerWarrantyDescription nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table Helmet.HelmetColorSpecificationInfo
(
HelmetColorSpecificationInfo_InfoID INT IDENTITY(1,1) PRIMARY KEY,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table Helmet.HelmetVariationDataInfo
(
HelmetVariationData_InfoID int identity(1,1) primary key,
Parentage nvarchar(6) not null,
VariationTheme nvarchar(10) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)